WIP Detail Ledger
The WIP Detail Ledger report includes detail for all unbilled WIP. This report includes a balance forward as of the starting date of the report, and the detail of all unbilled WIP within the date range. Balance forward is calculated based on the date range entered and only includes nonhistoric WIP.
Permissions Required for this Report
In the staff profile, staff must be assigned to a security group that is granted View functional rights for the following:
- Security group profile > Functional rights > Reports > Shared Library > Shared Views
- Security group profile > Functional rights > Reports > Firm Library > Custom
- Security group profile > Functional rights > Reports > Firm Library > Standard > Firm
- Security group profile > Functional rights > Reports > Firm Library > Standard > Practice
- Security group profile > Functional rights > Reports > Firm Library > <report name>
- Security group profile > Functional rights > Administration Manager > Client Manager > Approved Clients
Reports in Foundation that are Comparable
In Practice Management, there is no comparable report. In Practice Advantage, the comparable report is WIP Detail Ledger.
Report Specifications
The following report options and filters are available to determine report contents.
Options and Settings | ||
---|---|---|
Option | Setting | Description |
Show Last Bill |
Yes/No |
Includes or excludes the client’s last bill date and amount. |
Show Last Payment |
Yes/No |
Includes or excludes the client’s last payment date and amount. |
Show Current Fiscal Year Write Up/Downs |
Yes/No |
Includes or excludes the client’s current fiscal year write up/downs. |
Show AR Balance |
Yes/No |
Includes or excludes the clients AR balance. |
Show Client Address |
Yes/No |
Includes or excludes the client’s primary address. |
Show Invoice Description |
Yes/No |
Includes or excludes the invoice description for each transaction. |
Show Note |
Yes/No |
Includes or excludes the invoice notes for each transaction. |
Hide Comma |
Yes/No |
Includes or excludes commas in numbers. |
Hide Penny |
Yes/No |
Includes or excludes pennies in amounts. |
Hide Details |
Yes/No |
Includes or excludes details of each transaction. If hidden, select to subtotal your groups to view the amounts for each selected grouping. |
Default Filters | ||
---|---|---|
Field Name | Operator | Value |
Transaction Date |
Between |
First Day of Current Fiscal Year, Last Day of Current Fiscal Year |
Optional Filters | ||
---|---|---|
Available Fields | ||
Accounting Period Date |
Client – Principal |
Client ID.Sub ID |
Business Code |
Client Bill Manager |
Client Name |
Category ID |
Client Billing Group |
Client Office |
Category Name |
Client Business Unit |
Client Primary Service Type |
Client |
Client ID |
Client Region |
Client Sub ID |
Project |
Sort Name |
Client Type |
Project ID |
Staff ID |
Financial Reporting Client Group |
Project Name |
Subcategory ID |
Line of Business |
Project Office |
Subcategory Name |
Manager |
Return Group |
Tax Type |
Posted Date |
Service Code ID |
Transaction Date |
Primary Partner |
Service Code Name |
|
Grouping | ||
---|---|---|
Available Fields | ||
Business Code |
Client Office |
Project Name |
Category ID |
Client Primary Service Type |
Project Office |
Category Name |
Client Region |
Service Code ID |
Client |
Client Sub ID |
Service Code Name |
Client – Principal |
Client Type |
Sort Name |
Client Bill Manager |
Financial Reporting Client Group |
Staff |
Client Billing Group |
Line of Business |
Staff ID |
Client Business Unit |
Manager |
Subcategory ID |
Client ID |
Primary Partner |
Subcategory Name |
Client ID.Sub ID |
Project |
|
Client Name |
Project ID |
|
Sorting | ||
---|---|---|
Available Fields | ||
Amount |
Date |
Service Code Name |
Client |
Hours |
Staff ID |
Client ID |
Project |
Staff Name |
Client Name |
Rate |
|
Report Fields
The following fields are available for this report. The fields that display and the position of fields are based on the report's settings, grouping, sorting, and filters.
Report Fields | |
---|---|
Field | Description |
Project |
The project associated with the WIP transaction. If there is no project, unassigned displays. |
Client |
The client name and ID. The format is Client Sort Name (Client ID.Sub-ID). |
Last Bill |
The client’s last invoice date and amount |
Last Paid |
The client’s last payment date and amount. |
YTD Write up/downs |
The client’s total write ups/downs for the current fiscal year. |
AR Balance |
The client’s AR balance. |
Client ID |
The Client ID Sub ID associated with the WIP. |
Client Name |
The client name associated with the WIP. |
Balance Forward |
The total unbilled WIP as of the beginning date of the report. |
Date |
The date of the transaction. |
Staff ID |
The staff ID associated with the WIP. |
Staff |
The staff last name, first name associated with the WIP. |
Service Code |
The service code name associated with the WIP. |
Hours |
The total hours for the transaction. |
Rate |
The rate for the transaction. |
Amount |
The total amount for the transaction. |
WIP Detail Ledger Sample Report